AD 98-06-28
Registered aircraft · 175
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:98-06-28')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-06-28')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:98-06-28') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-06-28') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N335RCN335 Aviation Corp · Middletown, DEN351ASRoyal Air Freight Inc · Waterford, MIN351PJPremier Jets Inc · Hillsboro, ORFirst renewal noticeN351TXDodson International Parts Inc · Rantoul, KSN352CKKalitta Charters LLC · Ypsilanti, MIN352PJPremier Jets Inc · Hillsboro, ORN352PMEleven Eleven Holdings LLC · Middletown, DEN353CKKalitta Charters LLC · Ypsilanti, MIN354CKKalitta Charters LLC · Ypsilanti, MIN355KCN331us LLC · Hillsboro, ORN357CKKalitta Charters LLC · Ypsilanti, MIN357LJJet Rescue USA Inc · Boca Raton, FLN358CKAirnet II LLC · Columbus, OHN359CKAirnet II LLC · Columbus, OHN35AEAmerican Fidelity Corp Trustee · Dover, DEN35LJDelta Bravo LLC · Taylorville, ILN35WB253217 Corp · Sumas, WAN35WLKalitta Charters LLC · Ypsilanti, MIN367DAGlobal Aviation Inc · Hillsboro, ORN36SPKentucky State Police · Frankfort, KYN37ACAircraft Holding Solutions LLC Trustee · Newark, DEN384CFMed Air LLC · Wilmington, DEN389AWAir Gato Enterprises Inc · Clearwater, FLN38MGBay Venture Management LLC · Atlanta, GAN38PSAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedN393SCN169px LLC · Delaware, OHN400CZDodson International Parts Inc · Rantoul, KSFirst renewal noticeN417BARoyal Air Freight Inc · Waterford, MIN41RARoyal Air Freight Inc · Waterford, MIN421SVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN429MSFci Aeronautics LLC · Marble Falls, TXN431CKKalitta Charters LLC · Ypsilanti, MIN433DDE D Santos & Associates LLC · Wilmington, DEN43MFMed Flight Air Ambulance Inc · Albuquerque, NMN4415WDodson International Parts Inc · Rantoul, KSN441PCAero Jet Aviation I Inc · Fort Lauderdale, FLN453AMN543am LLC · Englewood, CON460SBIndigo Aviation LLC · Mcallen, TXN469BBCentex Aero LLC Trustee · San Antonio, TXN46MFMed Flight Air Ambulance Inc · Albuquerque, NMN474KAIce9 Lear35 LLC · Boulder, CON47MFMed Flight Air Ambulance Inc · Albuquerque, NMN47RARoyal Air Freight Inc · Waterford, MIN49WLRfs Air LLC · Tucson, AZN4EASaldana Air LLC · Huntley, ILN500LLBlackbird Aero LLC · Boca Raton, FLN505GJMed Air LLC · Wilmington, DEN508YVDodson International Parts Inc · Rantoul, KSFirst renewal noticeN50ANAeronet Consulting Trustee Corp · Miami, FLN50FNGh Equipment LLC · Wilmington, DE
Back to AD 98-06-28